﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_MJZBL')
            and   type = 'U')
   drop table GXBZ_EMR_MJZBL
go

/*==============================================================*/
/* Table: GXBZ_EMR_MJZBL                                        */
/*==============================================================*/
create table GXBZ_EMR_MJZBL (
   BLLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   KSBM                 varchar(64)          null,
   KSMC                 varchar(32)          null,
   YLJGDM               varchar(22)          not null,
   YLJGMC               varchar(70)          not null,
   JZRQSJ               datetime             null,
   JDYSGH               varchar(64)          null,
   JDYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   JLRQ                 datetime             null,
   ZRYSGH               varchar(64)          null,
   ZRYSXM               varchar(30)          null,
   GMSBZ                varchar(1)           null,
   GMSMS                varchar(100)         null,
   ZSMS                 varchar(1024)        null,
   XBS                  varchar(1024)        null,
   JWS                  varchar(1024)        null,
   TGJC                 varchar(500)         null,
   CZBZDM               varchar(1)           null,
   SZGCJG               varchar(100)         null,
   XYCZDM               varchar(64)          null,
   XYCZMC               varchar(512)         null,
   ZYCZBMDM             varchar(64)          null,
   ZYCZBMMC             varchar(512)         null,
   ZYCZZHDM             varchar(64)          null,
   ZYCZZHMC             varchar(512)         null,
   BZYJ                 varchar(100)         null,
   ZZZF                 varchar(100)         null,
   YZXMLXDM             varchar(2)           null,
   YZXMLXMC             varchar(32)          null,
   YZJHKSRQ             datetime             null,
   YZJHJSRQ             datetime             null,
   YZXMMS               varchar(1024)        null,
   YZZXRQ               datetime             null,
   YZZXZXM              varchar(50)          null,
   YZZXKSMC             varchar(100)         null,
   YZKLRQ               datetime             null,
   YZKLZXM              varchar(50)          null,
   YZKLKSMC             varchar(100)         null,
   YZSHRQ               datetime             null,
   YZSHRXM              varchar(50)          null,
   YZQXRQ               datetime             null,
   YZQXZXM              varchar(50)          null,
   YZBZXX               varchar(1024)        null,
   YZZXZT               varchar(50)          null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_MJZBL primary key (BLLSH, XGBZ)
)
go
